A Reliable Parallel Backend Using Multiattribute Clustering and Select- Join Operator
نویسندگان
چکیده
An access method based upon muhi-afiribure clustering allows fhe database administrafor to define muhiply parlilioned relalions. For each attribute in the clusrering, we can consider the set of subrelations as a relarion view. Such a method has been implemented in SABRE. II relies on muhi-a~tribute digital hashing and a linearly growing directory. Using this method, we show that it is possible IO improve the multiprocessor hashing join algorilhms by a ratio of 3 to 5, with rhe same hardware configurarion. According IO our evaluation, the memory requirements are approximately the same as wirh the hashing algori#uns, and the common bus used for disk accesses does not salurate. Any configurarion can be linearly extended by adding or removing a disk or a processor, and reIiabilily is guaranteed by a simple management of multiple copies. In case of a disk breakdown, the conrinualion of operalion is possible wirh minimum loss of speed.
منابع مشابه
Parallel Processing of Multi-Join Expansion_aggregate Data Cube Query in High Performance Database Systems
Data cube queries containing aggregate functions often combine multiple tables through join operations. We can extend this to “Multi-Join Expansion_Aggregate” data cube queries by using more than one aggregate functions in “SELECT” statement in conjunction with relational operators. In parallel processing for such queries, it must be decided which attribute to use as a partitioning attribute, i...
متن کاملComplex Query JOIN Optimization in Parallel Distributed Environment
The research work covers the query optimization concept in parallel distributed environment. The queries considered are select-project-join (SPJ) queries with large databases. The main query operation considered for research is JOIN operation of the query. For fast execution of a complex query, JOIN operation time needs to be minimized. Different JOIN operation algorithms such as Network Byte O...
متن کاملAn evaluation of the performance of parallel database operators using Phoenix MapReduce
The database join operator is the most expensive operator of the relational algebra operators. Many highly efficient sequential and parallel operators exist, based on several core techniques: sort-merge, hash and nested-loops. We present the design and implementation of two parallel operators: an equi-join and a grouping aggregation. They utilise the emerging MapReduce paradigm, specifically a ...
متن کاملAn Efficient Cluster Head Selection Algorithm for Wireless Sensor Networks Using Fuzzy Inference Systems
An efficient cluster head selection algorithm in wireless sensor networks is proposed in this paper. The implementation of the proposed algorithm can improve energy which allows the structured representation of a network topology. According to the residual energy, number of the neighbors, and the centrality of each node, the algorithm uses Fuzzy Inference Systems to select cluster head. The alg...
متن کاملImplementation and Analysis of Join Algorithms to handle skew for the Hadoop Map/Reduce Framework
he Map/Reduce framework-a parallel processing paradigm-is widely being used for large scale distributed data processing. Map/Reduce can perform typical relational database operations like selection, aggregation, and projection etc. However, binary relational operators like join, cartesian product, and set operations are difficult to implement with Map/Reduce. Map/Reduce can process homogeneous ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1998